﻿CREATE VIEW vantageexport.v_Tasks
AS
SELECT     CE.LoanID, FU.Comments AS Note, CASE fu.status WHEN 'To Be Done' THEN 137 ELSE 113 END AS StatusID, FU.CreatedDate AS StatusDate, 
                      FU.CreatedUser AS StatusUser, FU.DueDate AS DateDue, FU.CreatedUser AS DateDueBy, 1 AS NoteTypeID, 186 AS NoteActionCodeID, 
                      dbo.clr_RegEx_MatchGroup(FU.Comments, N'(\d\d\d\D{0,2}\d\d\d\D{0,1}\d\d\d\d)', 1) AS Phone, 0 AS PhoneCategoryID, FU.CreatedDate AS NoteDate, 
                      1 AS IsTask, FU.CreatedUser AS NoteUser, dbo.Today(FU.CreatedDate) AS NoteDate0, dbo.Time(FU.CreatedDate) AS NoteDate1, 1 AS IsResolved, 
                      1 AS IsCollection, FU.Target_FollowupID AS VantageID
FROM         usix.v_CustomerFile_Export_List AS CE INNER JOIN
                      Vantage_In.dbo.Target_Followup AS FU ON CE.VantageID = FU.Accountnumber
WHERE     (NOT (FU.Comments LIKE N'PTP Created on %'))

GO
EXECUTE sp_addextendedproperty @name = N'MS_DiagramPane1', @value = N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[34] 4[27] 2[7] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "FU"
            Begin Extent = 
               Top = 6
               Left = 275
               Bottom = 232
               Right = 446
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "CE"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 290
               Right = 239
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 20
         Width = 284
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1935
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
         Width = 1500
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 6525
         Alias = 1335
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End', @level0type = N'SCHEMA', @level0name = N'vantageexport', @level1type = N'VIEW', @level1name = N'v_Tasks';


GO
EXECUTE sp_addextendedproperty @name = N'MS_DiagramPaneCount', @value = 1, @level0type = N'SCHEMA', @level0name = N'vantageexport', @level1type = N'VIEW', @level1name = N'v_Tasks';

